mysqldefaultcharsetutf8

utf8mb3:AUTF-8encodingoftheUnicodecharactersetusingonetothreebytespercharacter.ThischaractersetisdeprecatedinMySQL8.0,andyoushould ...,2010年8月18日—TosetthedefaulttoUTF-8,youwanttoaddthefollowingtomy.cnf/my.ini[client]default-character-set=utf8mb4[mysql] ...,Eachcharactersethasadefaultcollation.Forexample,thedefaultcollationsforutf8mb4andlatin1areutf8mb4_0900_ai_ciandlatin1_swedish_ci, ...,Fo...

參考資訊如下
10.10.1 Unicode Character Sets

utf8mb3 : A UTF-8 encoding of the Unicode character set using one to three bytes per character. This character set is deprecated in MySQL 8.0, and you should ...

Change MySQL default character set to UTF

2010年8月18日 — To set the default to UTF-8, you want to add the following to my.cnf/my.ini [client] default-character-set=utf8mb4 [mysql] ...

10.2 Character Sets and Collations in MySQL

Each character set has a default collation. For example, the default collations for utf8mb4 and latin1 are utf8mb4_0900_ai_ci and latin1_swedish_ci , ...

10.5 Configuring Application Character Set and Collation

For applications that store data using the default MySQL character set and collation ( utf8mb4 , utf8mb4_0900_ai_ci ), no special configuration should be ...

安裝MySQL 與設定真・UTF-8 編碼

2023年6月6日 — MySQL 歷史遺留的老問題：utf8 是假的UTF-8，utf8mb4 才是真的UTF-8，必須改一下設定檔才能正確的指定使用真・UTF-8 編碼。

MySQL 編碼

先設定mysqld 服務的編碼 [root@csie5 ~]# vim /etc/my.cnf [mysqld] default-character-set=utf8 default-collation=utf8_unicode_ci character-set-server=utf8 ...

MySQL 將預設資料庫編碼latin1 改為UTF8

2015年11月13日 — mysql> ALTER DATABASE dbdata CHARACTER SET utf8 COLLATE ... default-character-set=utf8 dbdata < dbdata_utf8.sql. 在這邊資料庫修改 ...

mysql编码问题——charset=utf8你真的弄明白了吗？ 原创

2020年5月26日 — 导读：以前学习mysql的时候，一直不知道“charset=utf8”是什么意思，更不知道“set names gbk”是什么意思，通过这篇文章将会给大家详细介绍客户端字符 ...

設定MariaDB MySQL 真・UTF-8 編碼

2021年5月18日 — MariaDB 遺傳了MySQL 的老問題，utf8 是假的UTF-8，utf8mb4 才是真的UTF-8，必須改一下MariaDB 的設定檔才能正確的指定使用真・UTF-8 編碼。

10.9.3 The utf8 Character Set (Alias for utf8mb3)

utf8 has been used by MySQL is an alias for the utf8mb3 character set, but this usage is being phased out; as of MySQL 8.0.28, SHOW statements and columns ...